SQL Interview Questions and Answers
Test your skills through the online practice test: SQL Quiz Online Practice Test
Ques 66. The most important DDL statements in SQL are:
CREATE TABLE - creates a new database table
ALTER TABLE - alters (changes) a database table
DROP TABLE - deletes a database table
CREATE INDEX - creates an index (search key)
DROP INDEX - deletes an index
Is it helpful?
Add Comment
View Comments
Ques 67. Operators used in SELECT statements.
= Equal
or != Not equal
> Greater than
< Less than
>= Greater than or equal
<= Less than or equal
BETWEEN an inclusive range
LIKE Search for a pattern
Is it helpful?
Add Comment
View Comments
Ques 68. SELECT statements:
SELECT * FROM WITHOUTBOOK;
Is it helpful?
Add Comment
View Comments
Ques 69. The INSERT INTO Statements:
INSERT INTO WITHOUTBOOK(NAME,ADDRESS) VALUES('JOHN','GURGAON, INDIA');
Is it helpful?
Add Comment
View Comments
Ques 70. The Update Statement:
UPDATE WITHOUTBOOK SET ADDRESS='KOLKATA, INDIA' WHERE NAME='JOHN';
Is it helpful?
Add Comment
View Comments
Most helpful rated by users: